package com.trkj.dao.jpa;

import java.util.List;

import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojos.YzrStoreCount;

public interface IYzrStoreCountDAO extends CrudRepository<YzrStoreCount, String> {

	@Query("select max(ysc.storeCountId) from YzrStoreCount ysc where ysc.storeCountId like ?1%")
	public String findMaxId(String a);
	
	@Query("select ysc from YzrStoreCount ysc order by ysc.storeCountId desc")
	public List<YzrStoreCount> findAllCount(Pageable pageable);

}
